<%-- 
    Document   : view_posted_jobs
    Created on : Apr 12, 2012, 1:15:01 PM
    Author     : project
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>

<%@include file="header.jsp" %>
<%
            Connection con = Dbconn.getConn();
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("SELECT jobid,jobtitle,walkindate,validuntil,company.compid,compname FROM jobs,company where company.compid=jobs.compid  and jobs.status='Active' and validuntil>=CURDATE() ");
            
            
%>



<table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td align="left" valign="top">

            <span class='messagesred' style="text-align:center">
            </span>

            <table width="100%" border="0" cellspacing="0" >
                <tr>
                    <td width="100%" align="left" valign="top"><span class="mainheading_emp" style="margin-bottom:10px;">Posted Jobs</span></td>
                </tr>
                <tr>
                    <td height="10" align="center" valign="middle" class="normal"></td>
                </tr>
                <tr>
                    <td height="26" align="center" valign="middle"" class="normal"><table width="100%" height="144" border="0" cellspacing="2"  class="tbl_bdr">
                            <tr class="sde_mnu_hdr_blue" style="color:#000066;font-weight:bold" align="center">
                                <td width="16" height="37" align="left" valign="middle" class="subjeading" style="background-color: skyblue"><img style="margin-top:-5px; margin-left:-5px;" src="../images/top_left.gif";/></td>
                                <td width="115"  valign="middle" class="subjeading" style="background-color: skyblue">Logo</td>
                                <td width="169"  valign="middle" class="subjeading" style="background-color: skyblue">Company </td>
                                <td width="141"  valign="middle" class="subjeading" style="background-color: skyblue">Job Title  </td>
                                <td width="163"  valign="middle" class="subjeading" style="background-color: skyblue">Walk in Date </td>
                                <td width="163"  valign="middle" class="subjeading" style="background-color: skyblue">Expiry Date  </td>
                               
                                <td width="224"  valign="middle" class="subjeading" style="background-color: skyblue">Action</td>
                            </tr>

                            <%
                                int i=0;
                                while (rs.next()) { i++;
                            %>
                            <tr class="greybg" style="font-weight:bold" align="center">
                                <td align="center" valign="middle"><%=i%></td>
                                <td  valign="middle" ><img src="../src/getpic.jsp?id=<%=rs.getString("company.compid")%>&table=company&col=logo&pk_col=compid" width="71" height="50" border="0" /></td>
                                <td  valign="middle"><%= rs.getString("compname")%></td>
                                <td  valign="middle"><%= rs.getString("jobtitle")%></td>
                                <td  valign="middle"><%= rs.getString("walkindate")%></td>
                                <td  valign="middle"><%=rs.getString("validuntil")%></td>
                                
                                <td  valign="middle">

                                    <a href="viewjobdetails.jsp?jobid=<%=rs.getString("jobid")%>" title="View Job Details"><input id="submit" name="submit" type="submit" value="View Details" class="button2" style="width:120px; height:40px;"></a> </tr>&nbsp;&nbsp;
                                        <%}%>
										
										<tr align="center">
                <td width="16" height="30" align="center" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="115"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="169"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="141"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="163"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
				<td width="163"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="224"  valign="middle" class="subjeading" style="background-color: skyblue">&nbsp;</td>
                          </tr>
                        </table></td>
                </tr>
            </table></td>
    </tr>
</table>
<a href="http://apycom.com/"></a>